﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE sp_z4s_insert_test_data
	
AS
BEGIN	
	INSERT INTO Customer (c_id, c_name, c_address, c_age, c_inscriptionDate) VALUES ('EC031307-41E6-435F-A058-FC1BC867B61E', 'Bob', '23 **** Street', 32, CONVERT(DATETIME, '2009-01-25 09:55:00', 120));
	INSERT INTO Customer (c_id, c_name, c_address, c_age, c_inscriptionDate) VALUES ('C6F6BB86-EB35-41EF-A808-59FA8C0D7737', 'Nick', '156 **** Street', 52, CONVERT(DATETIME, '2011-03-01 09:00:00', 120));
	INSERT INTO Customer (c_id, c_name, c_address, c_age, c_inscriptionDate) VALUES ('2B7BEB44-D2DF-4C27-AE8A-920CD81B2D46', 'Nicolas', '8765 **** Street', 44, CONVERT(DATETIME, '2010-04-11 14:00:00', 120));
	INSERT INTO Customer (c_id, c_name, c_address, c_age, c_inscriptionDate) VALUES ('95E5C8C0-CC97-48BA-8E07-4FF79218F42B', 'Marshall', '11 **** Street', 43, CONVERT(DATETIME, '2005-06-01 12:33:00', 120));
	INSERT INTO Customer (c_id, c_name, c_address, c_age, c_inscriptionDate) VALUES ('10E229DB-08E9-45A0-AB0C-3D5ABA6338B1', 'Emily', '223 **** Street', 29, CONVERT(DATETIME, '2007-09-21 10:55:00', 120));
END
